<%@ page language="java"  pageEncoding="utf-8"%>
<%@ page import="java.util.Vector,java.util.ArrayList,com.ejoysoft.wlanyz.business.Disturb,com.ejoysoft.common.Constants,com.ejoysoft.common.exception.NoRightException" %>
<%@ include file="../include/jsp/head.jsp"%>
<%
if(!globa.userSession.hasRight("20020"))
      throw new NoRightException("用户不具备操作该功能模块的权限，请与系统管理员联系！");
%>

<%
    //初始化
    Disturb  Disturb0=null;
    Disturb obj=new Disturb(globa);
    //查询条件
    String  strCity = ParamUtil.getString(request,"strCity","");
    String  strStartTime1 = ParamUtil.getString(request,"strStartTime","");
    String  strEndTime1 = ParamUtil.getString(request,"strEndTime","");
      String strStartTime = strStartTime1;
    String strEndTime = strEndTime1;
    if(strStartTime1.compareTo(strEndTime1)>0)
       {
          out.print("<script>alert('起始时间大于终止时间，请重新输入');window.history.back(-1);</script>");  	
        } 
    
     //System.out.println("%%%%%%%%%%%%%%%"+strEndTime);
    if(strStartTime1 !=null && !strStartTime1.equals("")){
    String[] ST = strStartTime1.trim().split(" ");
    String[] ST2 = ST[0].split("-");
    if(ST2[0].length()==4){
    strStartTime1 = ST2[2] + "-"+ ST2[1] + "-" + ST2[0].substring(2)+" "+ST[1];
    }
     }
     if(strEndTime !=null && !strEndTime.equals("")){
    String[] ET = strEndTime.split(" ");
     String[] ET2 = ET[0].split("-");
     if(ET2[0].length()==4){
    strEndTime1 = ET2[2] + "-"+ ET2[1] + "-" + ET2[0].substring(2)+" "+ET[1];
    }
    }
    
	String tWhere=" WHERE 1=1";

    if(!strCity.equals("")){
     tWhere += " and a.strCity LIKE '%"+ strCity +"%'";
    }
    
      
	//记录总数
	int intAllCount=obj.getCount1(tWhere);	
	//当前页
    int intCurPage=globa.getIntCurPage();
	//每页记录数
	// int intPageSize=globa.getIntPageSize();
    String strPageSize = ParamUtil.getString(request,"strPageSize","10");
    int intPageSize;
    if(strPageSize.equals("所有"))intPageSize = intAllCount;
      else  intPageSize = Integer.parseInt(strPageSize);
	//共有页数
 	int intPageCount=(intAllCount-1)/intPageSize+1;
	// 循环显示一页内的记录 开始序号
	int intStartNum=(intCurPage-1)*intPageSize+1;
	//结束序号
	int intEndNum=intCurPage*intPageSize;   
	//获取到当前页面的记录集
	 
     
	Vector<Disturb> vctObj=obj.list1(tWhere,intStartNum,intPageSize,strStartTime1,strEndTime1);
	
	//获取当前页的记录条数
	int intVct=(vctObj!=null&&vctObj.size()>0?vctObj.size():0);
    ArrayList<Object[]> cityList = obj.getAllCitiesByName("");
    
   
%>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>测试干扰分析</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../css/main.css" rel="stylesheet" type="text/css" />
<link href="../common/css/css.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" src="../js/jquery-1.4.1.min.js"></script>
<script src="../include/DatePicker/WdatePicker.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css">
<!--
body {
	background-color: #f2f8ff;
}
.sel1{ width:160px;}
.STYLE1 {color: #FF0000}
.s6 a:link{ line-height:25px;height:25px; color:#2074b8;text-decoration:none}
.s6 a:hover{ line-height:25px;height:25px; color:#333333;text-decoration:none}
-->
</style>
 <link href="../jquerytable/Styles/Site.css" rel="stylesheet" type="text/css" />
 
    <script src="../jquerytable/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
    <script src="../jquerytable/Scripts/JQueryPlugin/TableSort.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $("#tb").sorttable({
                ascImgUrl: "../jquerytable/Images/bullet_arrow_up.png",
                descImgUrl: "../jquerytable/Images/bullet_arrow_down.png",
                ascImgSize: "8px",
                descImgSize: "8px",
                sorttingMsg: "数据加载中...",
                sorttingMsgColor: "#FF6600",
                 maskOpacity: "0.6",
                 maskColor:"#D2F1FF",
                onSorted: function (cell) {
                  //  alert(cell.index() + " -- " + cell.text());
                }
            });
        });
    </script>
<script type="text/javascript">

 function showAc(){ 

  frm.action="disturb_list.jsp";
  frm.<%=com.ejoysoft.common.Constants.PAGE_SIZE_INDEX%>.value = "1";
  frm.submit();
 }
 
 function export_sbm(page){ 
  frm.action="disturb_export.jsp";
  document.getElementById("strCurPage").value = "<%=intCurPage%>";;
  document.getElementById("exportContent").value = page;
  frm.submit();
 }
 
 function toDistrubTwo(city){
  frm.action = "disturb_country.jsp";
  document.getElementById("strPageSize").value = "";
  frm.<%=com.ejoysoft.common.Constants.PAGE_SIZE_INDEX%>.value = "1";
  document.getElementById("city").value = city;
  frm.submit();
 }
 
   function getCountry(city)
 {
 	 $("#strCountry").html("");	
 	 $("#strCountry").append("<option value=''>--请选择--</option>"); 
 	<%      
 		for (int j = 0; j <  cityList.size(); j++) {
			String city = (String)(cityList.get(j)[0]);
			ArrayList<String> coutry = (ArrayList<String>)(cityList.get(j)[1]);
			%>
			if(city == '<%=city%>')
			{ 
			<%
			  for(int i=0;i<coutry.size();i++){
			%>
				$("#strCountry").append("<option value='<%=coutry.get(i)%>'><%=coutry.get(i)%></option>");
			<%
			  }
			%>
			} 
			<%
		}
 	%>
 }
function clearInput(){
 	var selectId=document.getElementById('strCity');
 	for(var i=0;i<selectId.options.length;i++) 
	{ 
		if(selectId.options[i].text == "<%=strCity%>") 
		{ 
			selectId.options[i].selected = true; 
			//isExit = true; 
			break; 
		}else{
			selectId.options[0].selected = true; 
		} 
	}
	
	document.getElementById("strStartTime").value="<%=strStartTime %>";
 	document.getElementById("strEndTime").value= "<%=strEndTime %>";
 }
</script>
</head>

<body onload="clearInput();">
<form name="frm" METHOD=POST ACTION="disturb_list.jsp">
<input id="strHotSpot" name="strHotSpot" type="hidden" value=""/>
<input id="city" name="city" type="hidden" value=""/>
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30"><img src="../images/ri_list.jpg" width="14" height="14" align="absbottom" />&nbsp;您现在所在的位置：<font color="#0e7cc9">专项优化</font> &gt; 综合干扰分析</td>
  </tr>
</table>
<table  width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  
  <tr>
    <td height="45" valign="middle" bgcolor="e1eef7">
      <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td align="left" width="40%" height="40">城市(<span class="STYLE1">*</span>)
          <select name="strCity" class="sel1" style="width:100px" onchange="getCountry(this.value)">
          <option value="">--请选择--</option>
			 <% for (int j = 0; j <  cityList.size(); j++) {
					String city = (String)(cityList.get(j)[0]);
					String selected = "";
					if(strCity!= null && strCity.equals(city))
						selected = "selected='selected'";
				%>
				<option value="<%=city%>" <%=selected%>>
					<%=city%>
				</option>
				<%
				}
				%>
          </select></td>
          
           <td align="right" width="50%" >起止时间(<span class="STYLE1">*</span>)
	          <input  name="strStartTime" onclick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'});" class="input_box" value="<%=strStartTime %>"style="width:100"/>-
	          <input  name="strEndTime" onclick="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'});" class="input_box" value="<%=strEndTime %>"style="width:100"/>
          </td>
        <td width="%">&nbsp;</td>
        <td><img src="../images/search.jpg" width="58" height="28" onclick="showAc()" style="cursor:hand"/></td>
        </tr>
      </table></td>
  </tr>
</table>
<br>
<table  id="tb" width="97%" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr role="head">
    <td sort="true" width="13%" class="listtit">城市</td>
    <td sort="true" width="8%" class="listtit">区县数量</td>
    <td sort="true" width="16%" class="listtit">一级热点数量</td>
    <td sort="true" width="16%" class="listtit">AP数量</td>
    <td sort="true" width="8%" class="listtit">被干扰的AP数</td>
    <td sort="true" width="16%" class="listtit">信道质量</td>
    <td width="14%" class="listtit">拓扑定位</td>
    <td width="14%" class="listtit">下钻</td>
  </tr>
        <%
            for (int i = 0;i < vctObj.size(); i++) {
            	Disturb obj1 = vctObj.get(i);     
        %>
  <tr>
     <td align="center" class="listd1"><%=obj1.getCity() %></td>
    <td align="center" class="listdrd"><a href="#" onclick="toDistrubTwo('<%=obj1.getCity()%>')"><%=obj1.getcountryNum() %></a></td>
    <td align="center" class="listd1"><%=obj1.gethotSpotNum()%></td>
    <td align="center" class="listd1"><%=obj1.getApNum() %></td>
    <td align="center" class="listd1"><%=obj1.getApDisturbNum() %></td>
    <td align="center" class="listd1"><%=obj1.getApQuality() %></td>
    <td align="center" class="listdrd" ><a class="a1"href="#" onclick="window.parent.leftFrame.location='../left.jsp?actionFlag=拓扑呈现&rootFlag=日常管理';window.parent.mainFrame.location='../topology/allac_map.jsp?strCity=<%=obj1.getCity() %>';"><img src="../images/map_blue.png" height="20" border="0" /></a></td>
    <td align="center" class="listdrd" style="border-right:1px solid #dddddd;"><a href="#" onclick="toDistrubTwo('<%=obj1.getCity()%>')"><img src="../images/1-11112R01455.png" height="20" border="0" /></a></td>
  </tr>
         <%
           }//for 
         %>
  
</table>
s
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="61%" height="50" valign="bottom"><!--<img src="../images/pldel.jpg" width="83" height="27" align="absmiddle" />--> &nbsp;&nbsp;页面记录数
      <select name="strPageSize" id="strPageSize" style="width:52px;" onchange="showAc()">
		<% 
		 String sltOpt[] = {"10","20","30","50","70","100","所有"};
		 for(int i=0; i < sltOpt.length;i++){
		 	String selected = "";
		    if(sltOpt[i].equals(strPageSize))
		      selected="selected='selected'";
		%>
		 <option value="<%=sltOpt[i] %>" <%=selected %>><%=sltOpt[i] %></option>
   		<%
   		 }
   		 %>
		</select>
    <img src="../images/dc.jpg" width="92" height="27" align="middle"  onclick="export_sbm('currentPage')" style="cursor:hand"/> <img src="../images/dcall.jpg" width="82" height="27" align="middle" onclick="export_sbm('allPage')" style="cursor:hand"/></td>
    <td>  <input id="exportFlag" name="exportFlag" type="hidden" value="disturb_list"/>
       		 <input id="strCurPage" name="strCurPage" type="hidden" value=""/>
			<input id="exportContent" name="exportContent" type="hidden" value=""/></td>
    <td width="39%" align="right" valign="bottom"><!--<table width="310" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="40"><img src="../images/up.jpg" width="40" height="30" /></td>
        <td width="221" align="center" background="../images/page_bg.jpg" class="page"><a href="#">1</a>&nbsp; <a href="#">2</a>&nbsp; <a href="#">3</a>&nbsp; <a href="#"><span class="sel">4</span></a>&nbsp; <a href="#">5</a> &nbsp;<a href="#">6</a> &nbsp;<a href="#">7</a>&nbsp; <a href="#">8 </a>&nbsp;<a href="#">9</a>&nbsp;...&nbsp;<a href="#">13</a> </td>
        <td width="39"><img src="../images/down.jpg" width="39" height="30" /></td>
      </tr>
    </table>-->
    <!-- 翻页开始 -->  
     	<%@ include file="../include/jsp/cpage.jsp"%>
       	<!-- 翻页结束 --> </td>
    
  </tr>
</table>
</body>
</html>

<%@ include file="../include/jsp/footer.jsp"%>
